UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TgxX/5Ykpz5+Gud+CFrXPEU7itICxsai1mhyF+AAVKk=' 
WHERE 
  key_id = '45518370460d0968106f252d2be2ead6705dcb8a24aa82f24266f93f3461f46d' 
  AND (
    token = 'TgxX/5Ykpz5+Gud+CFrXPEU7itICxsai1mhyF+AAVKk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030