UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'naHZLjvF3qF3QHoI5wUEiOQ4B12bIUIlQDLBzK1hr9k='
WHERE
key_id = 'fdf8bdfdce8f1fd7b4e4e3a00652960b23a5b325f9fc32f12d620686b005b60f'
AND (
token = 'naHZLjvF3qF3QHoI5wUEiOQ4B12bIUIlQDLBzK1hr9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)