UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMXn0QIw59slThKsHQDrsBH0ta5csXp8ceEIPrvtjNo='
WHERE
key_id = 'f11180e441153ec11cb476dd53e740d2a6d6eafcfb78badafc6dff3b04f6e40a'
AND (
token = 'cMXn0QIw59slThKsHQDrsBH0ta5csXp8ceEIPrvtjNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)