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