UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUWy8aD+PqzqignkVZPkIEB1rxgXIyxLCza3NQN1Fp4='
WHERE
key_id = 'eff80513a381e0b8b00b2d31ff252b2aff1dfb4b4959f7baaa0653d578788425'
AND (
token = 'nUWy8aD+PqzqignkVZPkIEB1rxgXIyxLCza3NQN1Fp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)