UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fIFLwdZF8bDUdbde1I9Vs4dyUM8MGXNzAGLVEHN8zqA=' 
WHERE 
  key_id = 'a1b53bbed5b1c0bb97e5fa09a5cb8aec756b7f3d835fbe63433cc15926422bec' 
  AND (
    token = 'fIFLwdZF8bDUdbde1I9Vs4dyUM8MGXNzAGLVEHN8zqA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035