UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5ZSXr3juVWo5lrKlb3nd7d/cjqazLUzFiEv7vCmQCD8=' 
WHERE 
  key_id = '3b39e06d6d47c4c04dbae7ca18c22db68d3ce792354f779512b3313f3615e9aa' 
  AND (
    token = '5ZSXr3juVWo5lrKlb3nd7d/cjqazLUzFiEv7vCmQCD8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022