UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '02O2Ezgg+E9MT9Wf3KJXZDP7NlG79QICTZNORq0t+Hk=' 
WHERE 
  key_id = '40db0ed34006d128252bc5139e8a803450120c20d6c71ac2ad406fa1d08dce19' 
  AND (
    token = '02O2Ezgg+E9MT9Wf3KJXZDP7NlG79QICTZNORq0t+Hk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027