UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgiintsPNl18uw/RWwFqXzP53qZSM1QibPVs96SxNRc='
WHERE
key_id = 'a1e3d04a7d06214d6964d25629f87748aaad85e9c6fb774093df354354b8fb42'
AND (
token = 'KgiintsPNl18uw/RWwFqXzP53qZSM1QibPVs96SxNRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)