UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xBLOa1gX9zbghOQO/Ag1SF4L4IeJDHqx+M/n7hfCCtY=' 
WHERE 
  key_id = '7647ed5d1678797ba0191d6448795f7ddb75e09778af7426bc9b2aaea57dbd0e' 
  AND (
    token = 'xBLOa1gX9zbghOQO/Ag1SF4L4IeJDHqx+M/n7hfCCtY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029