UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krgLZ1H3exc/SrgHdWip1VzUaqDUf0R/us0QIq0BFRw='
WHERE
key_id = '8b3b1d0e94128d0b542704d734ad69368fad6dc40340b72450b0da90acfca9d8'
AND (
token = 'krgLZ1H3exc/SrgHdWip1VzUaqDUf0R/us0QIq0BFRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)