UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UoSwz0ZyB2MIQ1Yiakk99xmg+cIFcX4OSnAI7/8bOeI=' 
WHERE 
  key_id = 'd922146b82fc156874065978ccdee76cd3e999313765c7a224bebb48e78c5b19' 
  AND (
    token = 'UoSwz0ZyB2MIQ1Yiakk99xmg+cIFcX4OSnAI7/8bOeI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028