UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8KxpKh4sE4224TXVo4h9cg3K9GlJzXS3BWg9S8+yBLs=' 
WHERE 
  key_id = '9497f8ab937fb5b7e73d00885960b0b6f90d6a1b6029f5b8f6dd2ff6cced539d' 
  AND (
    token = '8KxpKh4sE4224TXVo4h9cg3K9GlJzXS3BWg9S8+yBLs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037