UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '43mUvqTfcK6DwQCT8OfuA8RhMvC5I8/2Dgi7CUFe2eA=' 
WHERE 
  key_id = '42d117506a56c05aac8cf332d6ad97658c1b9498b1086e2046765bc9f809f9f8' 
  AND (
    token = '43mUvqTfcK6DwQCT8OfuA8RhMvC5I8/2Dgi7CUFe2eA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027