UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '69ayJVdbY0nliAUMY9Him27nLFsMsZ7IPs4bfBhlpA8='
WHERE
key_id = '9b587e1b1d4e6e581899815cc6adc77dc26453c6549571e494e3fd1f0a2959dc'
AND (
token = '69ayJVdbY0nliAUMY9Him27nLFsMsZ7IPs4bfBhlpA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)