UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a/PYb1m/x852gP91uxGS3VAfL850o9pyimxghp3+sHo=' 
WHERE 
  key_id = '6c41e7b916b034a2faa918c256e33821c931eb6a7477c9cc432bd382487f9f32' 
  AND (
    token = 'a/PYb1m/x852gP91uxGS3VAfL850o9pyimxghp3+sHo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032