UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZaKWg7ks110neFMJY+ipYUD7XHXUUuXVbDywgaqJk9g=' 
WHERE 
  key_id = 'cc62213b97873f96d9f69e8d2de80ba333c77d3205af3e40f6810e6624c33ff8' 
  AND (
    token = 'ZaKWg7ks110neFMJY+ipYUD7XHXUUuXVbDywgaqJk9g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022