UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OepROCLEX5+C5nVuXcxtmx3g8UfeIk5r10jMiw085pU=' 
WHERE 
  key_id = 'afd324940901712140446d9cc659124134cf8a258e3c7a9f1a02880a587508bf' 
  AND (
    token = 'OepROCLEX5+C5nVuXcxtmx3g8UfeIk5r10jMiw085pU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027