UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HR5XlZ7Ta3GgnOf8AfXreoX8WqN7S1yLvRc/8x7xMMo=' 
WHERE 
  key_id = '0172d73d8efebc545fa1dbbc9ee6b00c78fe7c2ab3a3590c95a3bf47d76523e9' 
  AND (
    token = 'HR5XlZ7Ta3GgnOf8AfXreoX8WqN7S1yLvRc/8x7xMMo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044