UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KGh4AmnI+zwh3UHND5+Zz7POOA5SaG9MNJ5gRlaFmHc=' 
WHERE 
  key_id = 'd964faa530b73d6bce05057d91a10d54cdfc96c62a8130c68930bc9b0cfd62f7' 
  AND (
    token = 'KGh4AmnI+zwh3UHND5+Zz7POOA5SaG9MNJ5gRlaFmHc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046