UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBodc43IILx+5ElJnCp8PPUDG3XSAJirCGSC//rKAwU='
WHERE
key_id = 'd9c209b697b5cf6947295177d23eedd982f006f16197662e33e7a73572942a9f'
AND (
token = 'vBodc43IILx+5ElJnCp8PPUDG3XSAJirCGSC//rKAwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)