UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+ftEcuewZEOIszY3u88/PA0NyFes3laf4aBk6IfjbjM=' 
WHERE 
  key_id = '26dde1bf35bd26a25e46f66880e3f0640ac7dbc4d50cf717726c7d4de44eaa59' 
  AND (
    token = '+ftEcuewZEOIszY3u88/PA0NyFes3laf4aBk6IfjbjM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030