UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w25pRsfx76CHfHugS0/VKH9tQC9hYGBTTZnelPfc0u4=' 
WHERE 
  key_id = '6db19d25ffdc302e6f932a2ed55ad86051b0bafefe1c7445c8a355380de4e828' 
  AND (
    token = 'w25pRsfx76CHfHugS0/VKH9tQC9hYGBTTZnelPfc0u4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027