UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lwKD1+Wcdnz5e99c+GGM8A0qBeuBTnHaIDNHHM77zuw=' 
WHERE 
  key_id = '6f72c241088dd5a813866122b2e5d47a6ec3b24901aa8b12e06bf7deaa8437d1' 
  AND (
    token = 'lwKD1+Wcdnz5e99c+GGM8A0qBeuBTnHaIDNHHM77zuw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022