UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xbSyFIyQXHim+d0NTiZoC3YE0ITJMa5XleKes/5CwAo=' 
WHERE 
  key_id = 'ec7b5099410e710d325ea7f264838e7e7ced15d264b23607097cab6b3d3e68b7' 
  AND (
    token = 'xbSyFIyQXHim+d0NTiZoC3YE0ITJMa5XleKes/5CwAo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032