UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KrmYZMuAOM4uRNiGmSU7/Lmy3RkmwcNi5EvimunLFfY=' 
WHERE 
  key_id = '2f52d33e8e5daa0386fc4ee1400ad44aa7c9738778b8d0fd285c07f1ee833c75' 
  AND (
    token = 'KrmYZMuAOM4uRNiGmSU7/Lmy3RkmwcNi5EvimunLFfY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043