UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UY+RiZmN3b2jtPrw2fG+S7M//IuiuC7LScA9NvXPpq0=' 
WHERE 
  key_id = 'ad0e61e56c719f0d0071f909e49003bdeaeadb1b06cb50ba7b9bcff66f615e35' 
  AND (
    token = 'UY+RiZmN3b2jtPrw2fG+S7M//IuiuC7LScA9NvXPpq0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026