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