UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Sk+sNKv9B4NdR4aks8kt+cODW7+V0H23qpurAoh2vOc=' 
WHERE 
  key_id = '924bf13de0a988e3b8072a62b7031fc17a66f5a05f563ba8a997d892df54cd70' 
  AND (
    token = 'Sk+sNKv9B4NdR4aks8kt+cODW7+V0H23qpurAoh2vOc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020