UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mvgZ+GjV3w96pSNEjZ3tMy8FhdDAx5x7jm997dHK538='
WHERE
key_id = '7fdaddf9f9a92e8c02fe3952bf6d2ffa0d8e5aadeecd58fa8740d604b9adc305'
AND (
token = 'mvgZ+GjV3w96pSNEjZ3tMy8FhdDAx5x7jm997dHK538='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)