UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm4EpH6kQDpFB+30eb6EvBF74lpla73nQM7eBFru23mw=' 
WHERE 
  key_id = '7905bff9b00ba9cc846e6634dfa6feb3a6ab7fd2e4b6cb86d153a162a580ccc7' 
  AND (
    token = 'm4EpH6kQDpFB+30eb6EvBF74lpla73nQM7eBFru23mw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022