UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g/YvhrglBWbY42g+xI7TCIspdyW4GcIR6k1zaD8Qt3Y=' 
WHERE 
  key_id = '2703dccc7beb5fbe31bedd5341b36d31a4304a74f65c8eb5657f16f37b5ee8d5' 
  AND (
    token = 'g/YvhrglBWbY42g+xI7TCIspdyW4GcIR6k1zaD8Qt3Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023