UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Eif09zkQtEIU92m3XG4VclPB2Id/TqVi1y4pDYSHQQo=' 
WHERE 
  key_id = '3e8bf0f293f3724911c2e326b0c45816f45e166305c0d9412a46d00021ec342d' 
  AND (
    token = 'Eif09zkQtEIU92m3XG4VclPB2Id/TqVi1y4pDYSHQQo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047