UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lxLu3dD3np5F2z8FGSiV0le6qYi/OBtCGhjlV74Qjlo=' 
WHERE 
  key_id = 'd860e57d03182080356ca02a940c97b89d943f5a82498da9f58a20904c23fec2' 
  AND (
    token = 'lxLu3dD3np5F2z8FGSiV0le6qYi/OBtCGhjlV74Qjlo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020