UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '57580uJPcmRf2RBQpRmaYLyn70AZnkeQjlGkp+GUJRo='
WHERE
key_id = 'cae59f40a0d09ec6b4556302d6a844265fb0c3e10b6eb27e594a2b40a9569f74'
AND (
token = '57580uJPcmRf2RBQpRmaYLyn70AZnkeQjlGkp+GUJRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)