UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kB37H6J67kCa65UquUlaEUPaGKuFDq/E/u+jaHLFqus='
WHERE
key_id = '5a8d9ce602c4e2c006bd10c5469a97e6e8aecf2453204f9b8647b644cb01a7a0'
AND (
token = 'kB37H6J67kCa65UquUlaEUPaGKuFDq/E/u+jaHLFqus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)