UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xC7QcXOhUJFjqZVcBXGpB464qTCiYSy6U+voH2i/4BY='
WHERE
key_id = '8a2ddbc82dd402a9c9cbef25d29da5080b0daf40b5860c0259fefd6da162eb9f'
AND (
token = 'xC7QcXOhUJFjqZVcBXGpB464qTCiYSy6U+voH2i/4BY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)