UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCZ7/42lTP+vQstH0tB+yP81zLTvG1RSjaPdmIWL92o='
WHERE
key_id = '2b9bec5ee97419c86e94bce6474aecefd671a413cab98db5e8836b60d9cd13fb'
AND (
token = 'fCZ7/42lTP+vQstH0tB+yP81zLTvG1RSjaPdmIWL92o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)