UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VB3TGpfdg60P/iVVrFt54BOj8qmP0wpliiZjdW2uV1k='
WHERE
key_id = '54fb354af9886d958efc2b242a27eadf2587e9afcb4fdbc9a9b6db228920ff88'
AND (
token = 'VB3TGpfdg60P/iVVrFt54BOj8qmP0wpliiZjdW2uV1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)