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