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