UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zn5ouDz8Lhe8b5tUsgNOYjkrC0Vy0GXwNgXQkcAZUw='
WHERE
key_id = '77bc9f1bcc2c4259519c62e716dce7db82b1c911c43346df0fb65522f2e7abdf'
AND (
token = '4zn5ouDz8Lhe8b5tUsgNOYjkrC0Vy0GXwNgXQkcAZUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)