UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Yw6a6uwm+ScWfnIpr5Y0Zufv2jBmy+tQxcQVZqVpqn4=' 
WHERE 
  key_id = 'cccd09b0361f179b878613e15ccf082961cca3036af859a506ebfc277d79406f' 
  AND (
    token = 'Yw6a6uwm+ScWfnIpr5Y0Zufv2jBmy+tQxcQVZqVpqn4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035