UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFKCRHC+IcwTRM8gTw7Opo++OnHRtPgh+2h5k0USWW8='
WHERE
key_id = 'e4b43796bf614853c79a3afc822e9deedf1c47b072452451d229bcba0cd7a5c2'
AND (
token = 'gFKCRHC+IcwTRM8gTw7Opo++OnHRtPgh+2h5k0USWW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)