UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9w+r7AVNXf3f+PEx89nsUrMEWE8ehI46hagR1jlTbxA=' 
WHERE 
  key_id = 'ace5487e2b523f5716787ede8764c53d119937163330e99bfbd546f2b5c55790' 
  AND (
    token = '9w+r7AVNXf3f+PEx89nsUrMEWE8ehI46hagR1jlTbxA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042